Expressions.Numeric value function

A function returning a numeric value

Format

{ Extract expression |

Length expression |

Position expression |

Absolute value expression |

Modulus expression |

Natural logarithm |

Exponential function |

Power function |

Square root |

Floor function |

Ceiling function |

Regex occurrences function }

Remarks

A numeric function returns a numeric value and can be any one of the following:

• An EXTRACT function to return a date or time field from a datetime or interval. Refer to Extract expression for more details.
• A function returning the length of an item, such as CHAR_LENGTH, BIT_LENGTH, or OCTET_LENGTH. Refer to Length expression for more details.
• A POSITION function to return the position of a substring within another string. Refer to Position expression for more details.
• An ABS function to return the absolute value of an expression. Refer to Absolute value expression for more details.
• A MOD function to return the modulos of a value. Refer to Modulus expression for more details.
• A LN function to return the natrual logarithm of a value. Refer to Natural logarithm for more details.
• A EXP function to return e raised to the power of a value. Refer to Exponential function for more details.
• A POWER function to return one value raised to the power of another. Refer to Power function for more details.
• A SQRT function to return square root of another. Refer to Square root for more details.
• A FLOOR function to return a rounded down value of another. Refer to Floor function for more details.
• A CEILING function to return a rounded up value of another. Refer to Ceiling function for more details.
• An OCCURRENCES_REGEX function to return the number of times a pattern exists in another string. Refer to Regex occurrences function for more details.